/*
MySQL Backup
Database: jianzhi
Backup Time: 2025-03-09 20:57:29
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `jianzhi`.`aliyun_oss`;
DROP TABLE IF EXISTS `jianzhi`.`base_type`;
DROP TABLE IF EXISTS `jianzhi`.`base_user`;
DROP TABLE IF EXISTS `jianzhi`.`hr_info`;
DROP TABLE IF EXISTS `jianzhi`.`invite_message`;
DROP TABLE IF EXISTS `jianzhi`.`job_info`;
DROP TABLE IF EXISTS `jianzhi`.`job_label`;
DROP TABLE IF EXISTS `jianzhi`.`job_seeker`;
DROP TABLE IF EXISTS `jianzhi`.`jobseeker_job_relation`;
DROP TABLE IF EXISTS `jianzhi`.`pro_role`;
DROP TABLE IF EXISTS `jianzhi`.`recruit_unit`;
DROP TABLE IF EXISTS `jianzhi`.`recruit_unit_label`;
DROP TABLE IF EXISTS `jianzhi`.`resume`;
DROP TABLE IF EXISTS `jianzhi`.`school`;
DROP TABLE IF EXISTS `jianzhi`.`sys_menu`;
DROP TABLE IF EXISTS `jianzhi`.`sys_role`;
DROP TABLE IF EXISTS `jianzhi`.`sys_role_menu`;
DROP TABLE IF EXISTS `jianzhi`.`sys_user_role`;
DROP TABLE IF EXISTS `jianzhi`.`user`;
CREATE TABLE `aliyun_oss` (
  `id` int NOT NULL AUTO_INCREMENT,
  `file_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `file_path` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `source` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `used` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '文件用途（0:文件作废    1：头像    2：其他。求职者为简历，招聘方为审核文件）',
  `jobseeker_id` int DEFAULT NULL,
  `recruit_unit_id` int DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;
CREATE TABLE `base_type` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户id',
  `username` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '方案类型（如导出excel）',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '方案内容',
  `source_page` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '来源页',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
CREATE TABLE `base_user` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '密码',
  `type` tinyint DEFAULT '1' COMMENT '用户类型： 1 求职者 2 招聘单位  3管理员（ 超级和普通）',
  `company_code` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '企业号',
  `ip` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '访问的ip地址',
  `wechat` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '微信号',
  `emp_id` bigint DEFAULT NULL COMMENT '关联的职员id',
  `salt` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '密码加盐',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态 0 未启用（已注销） 1 启用',
  `creator` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updator` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '修改者',
  `update_time` datetime DEFAULT NULL COMMENT '修改日期',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=54379437274693633 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='用户表（门户+管理）';
CREATE TABLE `hr_info` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'HRid',
  `user_id` bigint DEFAULT NULL COMMENT '用户表id',
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'hr姓名',
  `sex` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '0男  1女',
  `recruit_unit_id` int DEFAULT NULL COMMENT '所属单位',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;
CREATE TABLE `invite_message` (
  `id` int NOT NULL,
  `sender_id` int DEFAULT NULL COMMENT '发送者id（user_id）',
  `receiver_id` int DEFAULT NULL COMMENT '接收者id（user_id）',
  `is_read` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '是否阅读（0未读  1已读）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `read_time` datetime DEFAULT NULL COMMENT '阅读时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;
CREATE TABLE `job_info` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '岗位信息id',
  `recruit_unit_id` int DEFAULT NULL COMMENT '招聘单位id',
  `job_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '岗位名称',
  `work_time` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '兼职时间',
  `location` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '地点',
  `label` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '兼职标签（日结、java、计算机、开发）',
  `detail` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '岗位描述（具体内容，地点）',
  `requirement` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '岗位要求，人员要求',
  `salary_treatment` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '薪资待遇',
  `status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '岗位状态（1已发布    2岗位已关闭    3岗位已删除）',
  `need_resume_attachment` int DEFAULT NULL COMMENT '是否需要简历附件（0不需要    1需要）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `creator` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '创建者userid',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `updator` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '更新者userid',
  `remark` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='岗位信息表';
CREATE TABLE `job_label` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '标签名',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;
CREATE TABLE `job_seeker` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '用户详细信息id',
  `user_id` bigint DEFAULT NULL COMMENT '用户表的id',
  `sex` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '0男 1女',
  `school_id` int DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '姓名',
  `sno` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '学号',
  `grade` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '年级',
  `birthday` date DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `wechat` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `qq` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `img` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '头像',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT COMMENT='求职者信息表';
CREATE TABLE `jobseeker_job_relation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `job_seeker_id` int DEFAULT NULL COMMENT '求职者id',
  `resume_id` int DEFAULT NULL COMMENT '简历id',
  `recruit_unit_id` int DEFAULT NULL COMMENT '招聘单位id',
  `job_id` int DEFAULT NULL COMMENT '岗位id',
  `status` int DEFAULT NULL COMMENT '简历状态（1待处理/已提交    2待沟通      3不合适       4录用）',
  `remark` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `creator` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `updator` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT COMMENT='求职者与岗位关系表';
CREATE TABLE `pro_role` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编号',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `creator` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
  `create_time` date DEFAULT NULL COMMENT '创建时间',
  `updator` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
  `update_time` date DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='生产角色表';
CREATE TABLE `recruit_unit` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '招聘方id',
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '招聘单位名称',
  `location` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '地址',
  `field` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '领域标签',
  `scale` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '规模',
  `profile` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '介绍',
  `status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '状态（0未通过审核  1审核中/待审核    2通过申请审核   3新注册用户/未认证   4被封禁）',
  `hr_id` int DEFAULT NULL COMMENT '企业注册者，也为管理者',
  `create_time` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '创建时间',
  `creator` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `updator` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT COMMENT='招聘单位表\r\n';
CREATE TABLE `recruit_unit_label` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;
CREATE TABLE `resume` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '简历id',
  `job_seeker_id` int DEFAULT NULL COMMENT '绑定求职者id',
  `res_name` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '简历姓名',
  `res_sex` varchar(4) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '0' COMMENT '简历性别 0男  1女',
  `res_expect_work` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '简历期望工作',
  `res_work_exper` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '工作经历【作废】',
  `res_project_exper` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '项目经验【作废】',
  `res_email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '邮箱',
  `res_phone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '联系方式',
  `res_desc` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '自我描述',
  `create_time` datetime DEFAULT NULL,
  `creator` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `updator` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `remark` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT COMMENT='简历信息【每个求职者只允许绑定一条 1对1 】';
CREATE TABLE `school` (
  `id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT;
CREATE TABLE `sys_menu` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '权限ID',
  `parent_id` bigint DEFAULT NULL COMMENT '父功能ID',
  `perms` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '权限标识',
  `type` tinyint DEFAULT NULL COMMENT '权限类别 0 菜单 1 按钮',
  `order_num` int DEFAULT NULL COMMENT '排序',
  `menu_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '权限名称',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '功能路由',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间戳',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间戳',
  `available` tinyint DEFAULT NULL COMMENT '0 禁用 1 启用',
  `open` tinyint DEFAULT NULL COMMENT '是否默认展开 (冗余字段，父级展开1，子级不展开为0)',
  `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图标',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=171 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='权限表';
CREATE TABLE `sys_role` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0   停用 1 启用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
CREATE TABLE `sys_role_menu` (
  `role_id` bigint DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint DEFAULT NULL COMMENT '权限ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='角色与权限关系表';
CREATE TABLE `sys_user_role` (
  `user_id` bigint DEFAULT NULL COMMENT '用户ID',
  `role_id` bigint DEFAULT NULL COMMENT '角色ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户与角色关系表';
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '密码',
  `company_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '企业号',
  `phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '手机',
  `email` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '邮箱',
  `wechat` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '微信号',
  `sex` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '性别',
  `salt` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '盐',
  `status` int DEFAULT '1' COMMENT '状态 0 未启用 1 启用',
  `is_del` int DEFAULT '0' COMMENT '逻辑删除标识',
  `creator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改者',
  `update_time` datetime DEFAULT NULL COMMENT '修改日期',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户表';
BEGIN;
LOCK TABLES `jianzhi`.`aliyun_oss` WRITE;
DELETE FROM `jianzhi`.`aliyun_oss`;
INSERT INTO `jianzhi`.`aliyun_oss` (`id`,`file_name`,`file_path`,`type`,`source`,`used`,`jobseeker_id`,`recruit_unit_id`) VALUES (106, '742f5ee500f868d8df2a47188f0bdf94', 'recruitUnit/1/1612100826754.jpg', 'jpg', 'recruitUnitImage', '0', NULL, 1),(107, 'b38b3d0e30af5509e2c11beda703d631', 'recruitUnit/3/1612577120864.jpg', 'jpg', 'recruitUnitImage', '0', NULL, 3),(108, 'f79e09a88c704942e7e0faf20dd9b839', 'jobSeeker/1/1612594312524.jpeg', 'jpeg', 'jobSeekerResume', '0', 1, NULL),(109, 'beijing', 'recruitUnit/1/1613021091199.jpg', 'jpg', 'recruitUnitImage', '0', NULL, 1),(110, 'ee', 'jobSeeker/1/1613097973862.jpeg', 'jpeg', 'jobSeekerResume', '2', 1, NULL),(112, 'q', 'jobSeeker/1/image1613109938297.jpg', 'jpg', 'jobSeekerImage', '0', 1, NULL),(113, '742f5ee500f868d8df2a47188f0bdf94', 'jobSeeker/1/image1613110355413.jpg', 'jpg', 'jobSeekerImage', '0', 1, NULL),(114, 'we', 'jobSeeker/1/image1613110374432.jpg', 'jpg', 'jobSeekerImage', '0', 1, NULL),(115, 'beijing', 'jobSeeker/1/image1613110474262.jpg', 'jpg', 'jobSeekerImage', '0', 1, NULL),(116, '742f5ee500f868d8df2a47188f0bdf94', 'jobSeeker/1/image1613110591894.jpg', 'jpg', 'jobSeekerImage', '0', 1, NULL),(117, 'd9ef3f6d00f286e48cd6295993c04425', 'jobSeeker/3/image1613111352896.jpg', 'jpg', 'jobSeekerImage', '0', 3, NULL),(118, 'f79e09a88c704942e7e0faf20dd9b839', 'jobSeeker/3/1614482950359.jpeg', 'jpeg', 'jobSeekerResume', '0', 3, NULL),(119, 'ee', 'jobSeeker/3/1614482996622.jpeg', 'jpeg', 'jobSeekerResume', '0', 3, NULL),(121, 'ee', 'jobSeeker/3/1614483893043.jpeg', 'jpeg', 'jobSeekerResume', '0', 3, NULL),(124, 'f79e09a88c704942e7e0faf20dd9b839', 'jobSeeker/3/1614483999296.jpeg', 'jpeg', 'jobSeekerResume', '0', 3, NULL),(128, 'f79e09a88c704942e7e0faf20dd9b839', 'jobSeeker/3/1614486655144.jpeg', 'jpeg', 'jobSeekerResume', '2', 3, NULL),(129, 'e49b23613811ce843057f9d4cc34e483', 'jobSeeker/1/image1614607705299.jpg', 'jpg', 'jobSeekerImage', '0', 1, NULL),(130, 'u=590710378,388937847&fm=11&gp=0', 'recruitUnit/1/1615304501292.jpg', 'jpg', 'recruitUnitImage', '0', NULL, 1),(131, 'download', 'recruitUnit/3/1615304549581.png', 'png', 'recruitUnitImage', '1', NULL, 3),(132, '算法', 'jobSeeker/1/image1615306860991.PNG', 'PNG', 'jobSeekerImage', '0', 1, NULL),(133, 'we', 'jobSeeker/1/image1615306876917.jpg', 'jpg', 'jobSeekerImage', '0', 1, NULL),(134, 'c811506d21fa1a29110ddffc1318dbdb', 'jobSeeker/1/image1619535634511.jpeg', 'jpeg', 'jobSeekerImage', '0', 1, NULL),(135, 'd6ce86777f8bcb2a3af309e6d72c6bd2', 'jobSeeker/1/image1619535785630.jpeg', 'jpeg', 'jobSeekerImage', '1', 1, NULL),(136, '9bfcd4d38d9722f49ee0eeace27f9d59', 'recruitUnit/1/1619694900911.jpeg', 'jpeg', 'recruitUnitImage', '1', NULL, 1),(137, 'download', 'jobSeeker/3/image1621259872297.jpg', 'jpg', 'jobSeekerImage', '1', 3, NULL),(138, 'u=3812336783,1127474957&fm=11&gp=0', 'jobSeeker/2/image1621261559204.jpg', 'jpg', 'jobSeekerImage', '1', 2, NULL),(139, '703b31b9e6444069bad3c7622b3ce2c2.docx', 'https://douyin-fan.oss-cn-beijing.aliyuncs.com/703b31b9e6444069bad3c7622b3ce2c2.docx', 'docx', NULL, '2', 6, NULL),(140, 'c3d063e532624e14813f6236a0d8e978.png', 'https://douyin-fan.oss-cn-beijing.aliyuncs.com/c3d063e532624e14813f6236a0d8e978.png', 'png', NULL, '1', 6, NULL),(141, '79dd5b193ae048ecbf75bbf788271763.png', 'https://douyin-fan.oss-cn-beijing.aliyuncs.com/79dd5b193ae048ecbf75bbf788271763.png', 'png', NULL, '1', NULL, 20),(142, '28766d457697419c927e07833d66c093.jpg', 'https://douyin-fan.oss-cn-beijing.aliyuncs.com/28766d457697419c927e07833d66c093.jpg', 'jpg', NULL, '1', NULL, 2),(155, 'fcde7abd478a441f9b467e1f00819c87.png', 'https://douyin-fan.oss-cn-beijing.aliyuncs.com/fcde7abd478a441f9b467e1f00819c87.png', 'png', NULL, '1', NULL, 0),(156, 'dd6e9bfbf6b94406bac8844065d9e3ab.jpg', 'https://douyin-fan.oss-cn-beijing.aliyuncs.com/dd6e9bfbf6b94406bac8844065d9e3ab.jpg', 'jpg', NULL, '2', NULL, 0)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jianzhi`.`base_type` WRITE;
DELETE FROM `jianzhi`.`base_type`;
INSERT INTO `jianzhi`.`base_type` (`id`,`user_id`,`username`,`type`,`content`,`source_page`) VALUES (1, '16932329429663820', 'cszy1', '123', 'custName,poundCode,recordPeople,sailDate,month,custType,proName,unit,priceWeight,priceVolume,unitProportion,falseRoughWeight,roughWeight,tareWeight,pureWeight,tranFee,tranDate,carNum,driver,driverPhone,remark,status,proPrice,totalPrice,checkStatus', '/poundList'),(2, '16932329429663820', 'cszy1', '1111', 'custName,poundCode,recordPeople,sailDate,month,custType,proName,unit,priceWeight,priceVolume,unitProportion,falseRoughWeight,roughWeight,tareWeight,pureWeight,tranFee,tranDate,carNum,driver,driverPhone,remark,status,proPrice,totalPrice,checkStatus', '/poundList'),(3, '1', 'cszy1', 'test2', 'name,code,advanceAmount,paymentStyle,deliveryTime,buildTime,validityTime,status,remark', '/order-management/quotation')
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jianzhi`.`base_user` WRITE;
DELETE FROM `jianzhi`.`base_user`;
INSERT INTO `jianzhi`.`base_user` (`id`,`username`,`password`,`type`,`company_code`,`ip`,`wechat`,`emp_id`,`salt`,`status`,`creator`,`create_time`,`updator`,`update_time`) VALUES (16932329429663820, 'xiaoming', 'cdee8f1de830f9c010ae616313be2030623c135dac264598331ae9a24997fafc', 1, NULL, NULL, NULL, 154, 'JhDFyiHsaKmkMBYJzgsz', 1, 'zzb2', '2020-11-02 09:33:09', 'zzb', NULL),(16932329429663826, 'changlong', 'cdee8f1de830f9c010ae616313be2030623c135dac264598331ae9a24997fafc', 2, NULL, NULL, NULL, 154, 'JhDFyiHsaKmkMBYJzgsz', 1, 'cszy1', '2021-02-06 01:32:08', 'cszy1', NULL),(20700498266947584, 'waimaixiaozi', 'cdee8f1de830f9c010ae616313be2030623c135dac264598331ae9a24997fafc', 2, NULL, NULL, NULL, NULL, 'JhDFyiHsaKmkMBYJzgsz', 1, NULL, '2021-01-30 23:02:14', NULL, NULL),(20717093480038400, 'jobseeker1', 'cdee8f1de830f9c010ae616313be2030623c135dac264598331ae9a24997fafc', 1, NULL, NULL, NULL, NULL, 'JhDFyiHsaKmkMBYJzgsz', 1, NULL, '2021-01-31 16:37:19', NULL, NULL),(20838525226188800, 'guanliyuan', 'cdee8f1de830f9c010ae616313be2030623c135dac264598331ae9a24997fafc', 3, NULL, NULL, '111ww', NULL, 'JhDFyiHsaKmkMBYJzgsz', 1, NULL, '2021-02-06 01:17:45', NULL, '2021-02-25 21:12:14'),(20858498822176768, 'maidanglao', 'cdee8f1de830f9c010ae616313be2030623c135dac264598331ae9a24997fafc', 2, NULL, NULL, NULL, NULL, 'JhDFyiHsaKmkMBYJzgsz', 1, NULL, '2021-02-06 22:27:38', NULL, NULL),(20986862173683712, 'xiaohua', 'cdee8f1de830f9c010ae616313be2030623c135dac264598331ae9a24997fafc', 1, NULL, NULL, NULL, NULL, 'JhDFyiHsaKmkMBYJzgsz', 1, NULL, '2021-02-12 14:28:45', NULL, NULL),(21186718681530368, 'xiaozhang', 'cdee8f1de830f9c010ae616313be2030623c135dac264598331ae9a24997fafc', 1, NULL, NULL, NULL, NULL, 'JhDFyiHsaKmkMBYJzgsz', 1, NULL, '2021-02-21 10:15:17', NULL, NULL),(21186718681530369, 'guanliyuan2', 'cdee8f1de830f9c010ae616313be2030623c135dac264598331ae9a24997fafc', 3, NULL, NULL, '123', NULL, 'JhDFyiHsaKmkMBYJzgsz', 1, NULL, '2021-02-23 22:39:36', NULL, '2021-02-25 21:29:11'),(21505364075216896, 'xiaojia', 'cdee8f1de830f9c010ae616313be2030623c135dac264598331ae9a24997fafc', 1, NULL, NULL, NULL, NULL, 'JhDFyiHsaKmkMBYJzgsz', 1, NULL, '2021-03-07 11:54:14', NULL, NULL),(21508635113291776, 'changlong2', 'cdee8f1de830f9c010ae616313be2030623c135dac264598331ae9a24997fafc', 2, NULL, NULL, NULL, NULL, 'JhDFyiHsaKmkMBYJzgsz', 1, NULL, '2021-03-07 15:22:12', NULL, NULL),(54355294993514496, 'fan', 'cdee8f1de830f9c010ae616313be2030623c135dac264598331ae9a24997fafc', 1, NULL, NULL, NULL, NULL, 'JhDFyiHsaKmkMBYJzgsz', 1, NULL, '2025-02-24 20:56:35', NULL, NULL),(54379437274693632, 'fantianzhi', 'ab51b0340ab910e02b656356d79993d17b149537632a8c2fb81a5d48cf6f0101', 2, NULL, NULL, NULL, NULL, 'YbeGRHMCirvmZjEGOsPB', 1, NULL, '2025-02-25 22:31:31', NULL, NULL)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jianzhi`.`hr_info` WRITE;
DELETE FROM `jianzhi`.`hr_info`;
INSERT INTO `jianzhi`.`hr_info` (`id`,`user_id`,`name`,`sex`,`recruit_unit_id`) VALUES (1, 16932329429663826, '长隆负责人', '1', 1),(3, 20700498266947584, '我是外卖小子负责人', '0', 3),(4, 21508635113291776, '长隆HR', '0', 1),(5, 54379437274693632, NULL, NULL, 4)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jianzhi`.`invite_message` WRITE;
DELETE FROM `jianzhi`.`invite_message`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jianzhi`.`job_info` WRITE;
DELETE FROM `jianzhi`.`job_info`;
INSERT INTO `jianzhi`.`job_info` (`id`,`recruit_unit_id`,`job_name`,`work_time`,`location`,`label`,`detail`,`requirement`,`salary_treatment`,`status`,`need_resume_attachment`,`create_time`,`creator`,`update_time`,`updator`,`remark`) VALUES (1, 1, '保安', '123', '珠海横琴', '{1}{2}{3}', '描述', '岗位要求，人员要求', '薪资待遇11', '1', 0, '2021-05-15 09:18:32', '16932329429663826', '2021-01-16 10:21:32', '16932329429663826', NULL),(5, 1, '后厨', '每周五', '长隆', '{11}', '1、负责后厨整理、清洁，保证正常使用；2、为厨师配好所需食材、保证食材新鲜、卫生等。', '学历要求初中，工作经验要求不限。', '50/天', '1', 0, '2021-01-16 16:28:25', '16932329429663826', '2021-04-29 16:31:40', '16932329429663826', NULL),(6, 1, '2211', '22', '22', '{3}', '1、负责后厨整理、清洁，保证正常使用；2、传达餐饮部或厨师长的相关通知、注意事项等；3、为厨师配好所需食材、保证食材新鲜、卫生等。', '2222', '22', '2', 0, '2021-01-16 16:29:52', '16932329429663826', '2021-01-16 16:31:28', '16932329429663826', NULL),(7, 3, '骑手', '每天', '南山', '{4}{3}{11}', '（1）严格按照操作流程,到指定地点进行取货;\r\n（2）确保按时将客户的订单,送到指定地点;', '（1）年龄18-45岁之间；\r\n（2）身体健康；\r\n（3）吃苦耐劳，认真负责，听从工作安排，对具体上岗时间有充分的适应性；\r\n（4）熟悉校园道路情况，以快捷地到达顾客所在地；\r\n（5）按标准完整执行骑手作业流程，遵守交通规则；\r\n（6）有配送工作经验者优先。', '12元/h', '1', 1, '2021-01-31 10:15:23', '20700498266947584', '2021-02-12 18:37:27', '20700498266947584', NULL),(8, 1, 'test', 'test', 'test', '{3}', 'test', 'test', 'test', '2', 0, '2021-02-19 00:44:29', '16932329429663826', '2021-04-27 22:55:36', '16932329429663826', NULL)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jianzhi`.`job_label` WRITE;
DELETE FROM `jianzhi`.`job_label`;
INSERT INTO `jianzhi`.`job_label` (`id`,`name`) VALUES (1, '计算机'),(2, 'Java'),(3, '日结'),(4, '骑手'),(10, '包吃'),(11, '有提成'),(12, '完结工')
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jianzhi`.`job_seeker` WRITE;
DELETE FROM `jianzhi`.`job_seeker`;
INSERT INTO `jianzhi`.`job_seeker` (`id`,`user_id`,`sex`,`school_id`,`name`,`sno`,`grade`,`birthday`,`phone`,`wechat`,`qq`,`email`,`img`) VALUES (1, 16932329429663820, '0', 1, '林伟杰', '234', '2017级', '2021-01-09', '132****5677', '12345', '124', '11122', NULL),(2, 20717093480038400, '1', 1, '小杰', '123', NULL, NULL, NULL, '456', '123', NULL, NULL),(3, 20986862173683712, '0', 1, '小花', '04175252', NULL, NULL, '1111111', NULL, NULL, '111', NULL),(4, 21186718681530368, '0', 1, '小张', '04181818', NULL, NULL, NULL, NULL, NULL, NULL, NULL),(5, 21505364075216896, NULL, 1, '1234', '1234', NULL, NULL, NULL, NULL, NULL, NULL, NULL),(6, 54355294993514496, NULL, 1, '范天志', '123456', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jianzhi`.`jobseeker_job_relation` WRITE;
DELETE FROM `jianzhi`.`jobseeker_job_relation`;
INSERT INTO `jianzhi`.`jobseeker_job_relation` (`id`,`job_seeker_id`,`resume_id`,`recruit_unit_id`,`job_id`,`status`,`remark`,`create_time`,`creator`,`update_time`,`updator`) VALUES (112, 1, 2, 1, 5, 4, NULL, '2021-03-07 16:37:00', NULL, '2021-05-17 22:01:01', NULL),(113, 1, 2, 1, 6, 3, NULL, '2021-03-07 22:16:38', NULL, '2021-04-27 22:58:19', NULL),(114, 1, 2, 1, 8, 2, NULL, '2021-03-07 22:18:13', NULL, '2021-04-27 22:58:20', NULL),(115, 3, 4, 1, 5, 2, NULL, '2021-03-07 22:18:33', NULL, '2021-03-10 00:21:31', NULL),(117, 2, 3, 1, 5, 2, NULL, '2021-05-13 20:54:27', NULL, '2021-05-17 22:59:38', NULL),(118, 2, 3, 1, 1, 2, NULL, '2021-05-14 23:15:55', NULL, '2021-05-18 21:57:36', NULL),(122, 1, 2, 1, 1, 2, NULL, '2021-05-18 22:03:34', NULL, '2025-02-24 21:23:30', NULL)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jianzhi`.`pro_role` WRITE;
DELETE FROM `jianzhi`.`pro_role`;
INSERT INTO `jianzhi`.`pro_role` (`id`,`code`,`name`,`creator`,`create_time`,`updator`,`update_time`,`remark`) VALUES (2, '2', '角色2', NULL, NULL, NULL, '2020-11-24', NULL),(3, '3', '角色3', NULL, NULL, NULL, '2020-11-24', NULL),(4, '4', '角色4', NULL, '2020-11-24', NULL, '2020-11-24', NULL)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jianzhi`.`recruit_unit` WRITE;
DELETE FROM `jianzhi`.`recruit_unit`;
INSERT INTO `jianzhi`.`recruit_unit` (`id`,`name`,`location`,`field`,`scale`,`profile`,`status`,`hr_id`,`create_time`,`creator`,`update_time`,`updator`) VALUES (1, '长隆', '珠海横琴', '{2}', '500人', '长隆集团旗下已建成并开放两大旅游度假区，即广州长隆旅游度假区和珠海横琴长隆国际海洋度假区。长隆集团的第三个度假区——清远长隆正在建设，定位为森林主题综合体。 长隆集团2019年接待游客接近4千万人次，其中珠海长隆海洋王国入园人数已突破千万，开业六年来保持稳定快速增长，跻身全球主题乐园前十。', '2', 1, NULL, NULL, '2021-02-06 10:40:02', NULL),(3, '外卖小子', '新饭堂', '{1}{3}', '10人', '用心做好每一份美食。', '2', 3, '2021-01-31 09:40:56', NULL, NULL, NULL),(4, NULL, NULL, NULL, NULL, NULL, '1', 5, '2025-02-25 22:44:52.164', NULL, NULL, NULL),(5, NULL, NULL, NULL, NULL, NULL, '1', 5, '2025-02-25 23:05:43.249', NULL, NULL, NULL)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jianzhi`.`recruit_unit_label` WRITE;
DELETE FROM `jianzhi`.`recruit_unit_label`;
INSERT INTO `jianzhi`.`recruit_unit_label` (`id`,`name`) VALUES (1, '餐饮'),(2, '景点'),(3, '外卖'),(4, '其它')
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jianzhi`.`resume` WRITE;
DELETE FROM `jianzhi`.`resume`;
INSERT INTO `jianzhi`.`resume` (`id`,`job_seeker_id`,`res_name`,`res_sex`,`res_expect_work`,`res_work_exper`,`res_project_exper`,`res_email`,`res_phone`,`res_desc`,`create_time`,`creator`,`update_time`,`updator`,`remark`) VALUES (2, 1, '小明12', '0', NULL, NULL, NULL, '545***545@qq.com', '1345***7878', NULL, NULL, NULL, '2021-03-06 18:59:08', NULL, NULL),(3, 2, 'jobseeker1', '1', NULL, NULL, NULL, 'ddddd@qq.com', '1111112', 'sdsvsdvdfvdfvdfvdfvdfvdfvfvdvdfdfv1', '2021-01-31 16:37:20', NULL, '2021-01-31 17:29:24', NULL, NULL),(4, 3, '小花', '1', NULL, NULL, NULL, '90702@QC.VOM', '1345***7877', 'SDSDSDSDDS', '2021-02-12 14:28:46', NULL, '2021-02-28 12:32:10', NULL, NULL),(5, 4, '123', '0', NULL, NULL, NULL, NULL, NULL, NULL, '2021-02-21 10:15:17', NULL, NULL, NULL, NULL),(6, 6, '范天志', '0', NULL, NULL, NULL, '485913144@qq.com', '15382728378', NULL, NULL, NULL, '2025-02-25 21:12:46', NULL, NULL)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jianzhi`.`school` WRITE;
DELETE FROM `jianzhi`.`school`;
INSERT INTO `jianzhi`.`school` (`id`,`name`) VALUES (1, '**学校')
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jianzhi`.`sys_menu` WRITE;
DELETE FROM `jianzhi`.`sys_menu`;
INSERT INTO `jianzhi`.`sys_menu` (`id`,`parent_id`,`perms`,`type`,`order_num`,`menu_name`,`url`,`create_time`,`update_time`,`available`,`open`,`icon`) VALUES (1, 0, '', 0, 1, '系统首页', '/index', NULL, NULL, 1, 0, ''),(2, 0, '', 0, 2, '基础数据', '', NULL, NULL, 1, 0, ''),(4, 2, 'permission', 0, 6, '角色管理', '/permission', NULL, NULL, 1, 0, ''),(5, 2, NULL, 0, 5, '菜单管理', '/menus-management', NULL, NULL, 1, 0, ''),(6, 2, 'users', 0, 4, '用户管理', '/user-management', NULL, NULL, 1, 0, ''),(23, 4, 'sysRole:authority', 1, 1, '角色授权', '', NULL, NULL, 1, 1, 'el-icon-document-add'),(24, 4, 'sysRole:add', 1, 2, '添加角色', '', NULL, NULL, 1, 1, 'el-icon-plus'),(25, 4, 'sysRole:update', 1, 3, '角色更新', NULL, NULL, NULL, 1, 0, 'el-icon-refresh-left'),(26, 4, 'sysRole:edit', 1, 4, '角色编辑', '', NULL, NULL, 1, 0, 'el-icon-s-promotion'),(27, 4, 'sysRole:delete', 1, 5, '角色删除', NULL, NULL, NULL, 1, 0, 'el-icon-s-marketing'),(28, 4, 'sysRole:status', 1, 6, '状态更新', NULL, NULL, NULL, 1, 0, 'el-icon-refresh'),(29, 5, 'sysMenu:add', 1, 1, '添加菜单', NULL, NULL, NULL, 1, 0, 'el-icon-plus'),(30, 5, 'sysMenu:edit', 1, 2, '编辑菜单', '', NULL, NULL, 1, 0, 'el-icon-edit'),(31, 5, 'sysMenu:update', 1, 2, '修改菜单', NULL, NULL, NULL, 1, 0, 'el-icon-share'),(32, 5, 'sysMenu:delete', 1, 4, '删除菜单', NULL, NULL, NULL, 1, 0, 'el-icon-s-opportunity'),(33, 6, 'user:assign', 1, 1, '分配角色', '', NULL, NULL, 1, 0, 'el-icon-s-tools'),(34, 6, 'user:status', 1, 2, '禁用用户', NULL, NULL, NULL, 1, 0, 'el-icon-circle-close'),(35, 6, 'user:delete', 1, 3, '用户删除', NULL, NULL, NULL, 1, 1, 'el-icon-remove'),(165, 0, '', 0, 1, '人员管理', '', NULL, NULL, 1, 0, NULL),(166, 0, NULL, 0, 4, '企业管理', NULL, NULL, NULL, 1, 0, NULL),(167, 0, NULL, 0, 5, '岗位管理', NULL, NULL, NULL, 1, 0, NULL),(168, 165, NULL, 0, 1, '111', NULL, NULL, NULL, 1, 0, NULL),(169, 166, NULL, 0, 1, '111', NULL, NULL, NULL, 1, 0, NULL),(170, 167, NULL, 0, 1, '111', NULL, NULL, NULL, 1, 0, NULL)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jianzhi`.`sys_role` WRITE;
DELETE FROM `jianzhi`.`sys_role`;
INSERT INTO `jianzhi`.`sys_role` (`id`,`role_name`,`remark`,`create_time`,`update_time`,`status`) VALUES (16, '所有权限', '', '2020-09-02 11:19:55', '2021-03-06 19:59:08', 1),(30, '求职者', NULL, '2021-02-21 16:56:46', '2021-03-06 19:59:56', 1),(31, '招聘单位-负责人', NULL, '2021-02-21 16:57:01', '2021-05-14 21:01:15', 1),(32, '招聘单位-普通用户', NULL, '2021-02-21 23:56:12', NULL, 1),(33, '超级管理员', NULL, '2021-02-21 16:57:14', NULL, 1),(34, '普通管理员', NULL, '2021-02-21 16:58:08', NULL, 1)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jianzhi`.`sys_role_menu` WRITE;
DELETE FROM `jianzhi`.`sys_role_menu`;
INSERT INTO `jianzhi`.`sys_role_menu` (`role_id`,`menu_id`) VALUES (16, 1),(16, 2),(16, 4),(16, 23),(16, 24),(16, 25),(16, 26),(16, 27),(16, 28),(16, 5),(16, 29),(16, 30),(16, 31),(16, 32),(16, 6),(16, 33),(16, 34),(16, 35),(16, 165),(16, 168),(16, 166),(16, 169),(16, 167),(16, 170),(34, 1),(34, 165),(34, 168),(34, 166),(34, 169),(34, 167),(34, 170),(33, 1),(33, 2),(33, 4),(33, 23),(33, 24),(33, 25),(33, 26),(33, 27),(33, 28),(33, 5),(33, 29),(33, 30),(33, 31),(33, 32),(33, 6),(33, 33),(33, 34),(33, 35),(33, 165),(33, 168),(33, 166),(33, 169),(33, 167),(33, 170)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jianzhi`.`sys_user_role` WRITE;
DELETE FROM `jianzhi`.`sys_user_role`;
INSERT INTO `jianzhi`.`sys_user_role` (`user_id`,`role_id`) VALUES (16932329429663820, 16),(20700498266947584, 16),(20717093480038400, 16),(20858339555016704, 16),(20858469386551296, 16),(20858498822176768, 16),(20986862173683712, 16),(21186718681530368, 16),(21289744868573184, 16),(21505364075216896, 16),(21508635113291776, 16),(16932329429663826, 16),(21186718681530369, 34),(20838525226188800, 16),(54355294993514496, 30),(54355294993514496, 16),(54379437274693632, 16)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `jianzhi`.`user` WRITE;
DELETE FROM `jianzhi`.`user`;
INSERT INTO `jianzhi`.`user` (`id`,`username`,`password`,`company_code`,`phone`,`email`,`wechat`,`sex`,`salt`,`status`,`is_del`,`creator`,`create_time`,`updator`,`update_time`,`remark`) VALUES (1, 'admin', '123456', '1', '15012345678', 'admin@126.com', NULL, '1', '1', 1, 0, NULL, NULL, NULL, NULL, NULL),(2, 'lzh', '123456', '1', '15012345678', 'lzh@126.com', NULL, '1', '1', 1, 0, NULL, NULL, NULL, NULL, NULL),(3, 'tc', '123456', '1', '15012345678', 'tc@126.com', NULL, '1', '1', 1, 0, NULL, NULL, NULL, NULL, NULL),(4, 'bowen', '2a2228fa6bd8fc5f929afaf7135cf6768b82296b5a29685d87eb36eb43bdd2ba', '1', '15012345678', 'bowen@126.com', '', '1', '1', 1, 0, '', NULL, NULL, NULL, NULL),(5, '1', '7d118be535c241b2898b4d96b57ca21da961fab6bfc0c612e8f464b1e9f8d2a7', '1', '15012345678', 'one@126.com', NULL, '1', '1', 1, 0, NULL, NULL, NULL, NULL, NULL)
;
UNLOCK TABLES;
COMMIT;
